Create database [UltimusDB_Archive]
GO


USE [UltimusDB_Archive]
GO

/****** Object:  Table [dbo].[INCIDENTS]    Script Date: 05/03/2013 16:16:37 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[INCIDENTS](
	[PROCESSNAME] [nchar](256) NOT NULL,
	[PROCESSVERSION] [int] NULL,
	[INCIDENT] [int] NOT NULL,
	[PRIORITY] [int] NULL,
	[SUMMARY] [nchar](512) NULL,
	[STARTTIME] [datetime] NULL,
	[ENDTIME] [datetime] NULL,
	[STATUS] [int] NULL,
	[INITIATOR] [nchar](512) NULL,
	[PARENTTASKID] [char](64) NULL,
	[TIMELIMIT] [datetime] NULL,
	[HELPURL] [varchar](2048) NULL,
	[MAINSS] [image] NULL,
 CONSTRAINT [INCCON] PRIMARY KEY CLUSTERED 
(
	[PROCESSNAME] ASC,
	[INCIDENT] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

/****** Object:  Table [dbo].[TASKS]    Script Date: 05/03/2013 16:16:37 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[TASKS](
	[TASKID] [char](64) NOT NULL,
	[PROCESSNAME] [nchar](256) NULL,
	[PROCESSVERSION] [int] NULL,
	[INCIDENT] [int] NULL,
	[STEPID] [char](64) NULL,
	[STEPLABEL] [nvarchar](128) NULL,
	[RECIPIENT] [nchar](256) NULL,
	[RECIPIENTTYPE] [int] NULL,
	[TASKUSER] [nchar](512) NULL,
	[ASSIGNEDTOUSER] [nchar](256) NULL,
	[STATUS] [int] NULL,
	[SUBSTATUS] [int] NULL,
	[STARTTIME] [datetime] NULL,
	[ENDTIME] [datetime] NULL,
	[QSTARTTIME] [datetime] NULL,
	[QENDTIME] [datetime] NULL,
	[DELAYTIME] [datetime] NULL,
	[OVERDUETIME] [datetime] NULL,
	[URGENTDUETIME] [datetime] NULL,
	[TASKRATE] [float] NULL,
	[TASKTIME] [int] NULL,
	[COST] [float] NULL,
	[HELPURL] [varchar](2048) NULL,
	[NOTES] [nvarchar](1024) NULL,
	[REFERER] [char](64) NULL,
	[LOCALSS] [image] NULL,
 CONSTRAINT [INCCON3] PRIMARY KEY CLUSTERED 
(
	[TASKID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


